=Chris Palmer · Data and Analytics Manager · Community Champion

• Activity
• Posts5
• Comments194

• Re: filter

  =Chris Palmer

  11/11/24
  Hello @Yan Lavallée People who use your sheet can only see your filter if this box is checked: Simply make sure it's unchecked and the filter is exclusive to you.
  1 ·

• Re: #BLOCKED

  =Chris Palmer

  04/19/23
  Hi @Karen Bruer, #BLOCKED errors occur when your formula is looking at a cell/column with another formula or value it can't read. I would check each column your formula touches and make sure there is…
  1 ·

• Re: How to Count multiple values within a single cell using COUNTIF Statement

  =Chris Palmer

  01/17/24
  Hi Dan, If I'm understanding your needs correctly, it might be helpful to simply reference the cell in your calculations in [General Issue]@row like so: =COUNTIFS({2024 Red List Clients General Issue…
  1 ·

• Re: RYG based on cell value

  =Chris Palmer

  01/30/24
  Hi @Sam C Something like this perhaps? =IF([Remaining]@row > 0, "Green", IF(AND([Remaining]@row >= 0, [Remaining]@row <= 0.5), "Yellow", "Red"))
  1 ·

• Re: How to Count multiple values within a single cell using COUNTIF Statement

  =Chris Palmer

  01/15/24
  Hello @ProductDan, I was able to replicate your scenario and the COUNTIFs formula worked when I removed "&" from the General Issue column. =COUNTIF([Drop Down Column]:[Drop Down Column]…
  1 ·